{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Analisis"],"not_rendered":{"charts":7,"images":7,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Analisis","index":0,"n_rows":55,"n_cols":24,"rows_kept":55,"cut":false,"hidden":false,"merged":[[2,4,4,4],[18,15,18,18],[50,1,52,2],[52,5,52,8],[53,1,54,3],[53,4,54,4],[48,1,49,3],[48,4,49,4],[20,17,20,19],[21,17,21,19],[45,1,47,2],[47,5,47,8],[35,4,37,4],[35,6,36,6],[35,7,36,7],[35,8,36,8],[38,1,39,2],[40,1,41,2],[42,1,44,2],[35,5,36,5],[20,1,21,3],[20,4,21,4],[19,5,19,8],[2,8,3,8],[6,15,7,16],[12,15,14,16],[9,15,11,16],[15,15,17,16],[2,5,3,5],[2,6,3,6],[2,7,3,7],[14,5,14,8],[3,15,4,16],[5,1,6,2],[15,1,16,3],[15,4,16,4],[17,1,19,2],[7,1,8,2],[9,1,11,2],[12,1,14,2]]}
[]
[]
[null,null,null,null,"Total","Línea de Negocio 1","Línea de Negocio 2","Línea de Negocio 3","Línea de Negocio 4",null,null,null,null,null,null,null,null,{"$f":"F5","v":"Gama Blanca"},null,{"$f":"G5","v":"Gama Marrón"},null,{"$f":"H5","v":"Muebles"},null,{"$f":"I5","v":"Electrónica"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D6","v":"Volumen de Vtas"},null,{"$f":"F39","v":78900},null,{"$f":"G39","v":45000},null,{"$f":"H39","v":458000},null,{"$f":"I39","v":26500}]
[null,null,null,null,null,"Gama Blanca","Gama Marrón","Muebles","Electrónica"]
[null,"Ingresos",null,"Volumen de Vtas",{"$f":"SUM(F6:I6)","v":608400},78900,45000,458000,26500,null,null,null,null,null,null,null,"Originales",{"$f":"F6","v":78900},null,{"$f":"G6","v":45000},null,{"$f":"H6","v":458000},null,{"$f":"I6","v":26500}]
[null,null,null,"Composición de las Vtas",{"$f":"SUM(F7:I7)","v":1},{"$f":"F6/$E$6","v":0.1296844181459566},{"$f":"G6/$E$6","v":7.3964497041420121E-2},{"$f":"H6/$E$6","v":0.7527942143326759},{"$f":"I6/$E$6","v":4.3556870479947406E-2},null,null,null,null,null,null,{"$f":"D8","v":"Margen Medio sobre Coste"},null,{"$f":"F41","v":18},null,{"$f":"G41","v":35},null,{"$f":"H41","v":150},null,{"$f":"I41","v":10}]
[null,"Costes Variables Directos",null,"Margen Medio sobre Coste",{"$f":"(E6-E9)/E9","v":0.97860962209552904},0.18,0.35,1.5,0.1]
[null,null,null,"Ventas al Coste Estimadas",{"$f":"SUM(F9:I9)","v":307488.64920390339},{"$f":"F6/(1+F8)","v":66864.406779661018},{"$f":"G6/(1+G8)","v":33333.333333333328},{"$f":"H6/(1+H8)","v":183200},{"$f":"I6/(1+I8)","v":24090.909090909088},null,null,null,null,null,null,null,"Originales",{"$f":"F8","v":0.18},null,{"$f":"G8","v":0.35},null,{"$f":"H8","v":1.5},null,{"$f":"I8","v":0.1}]
[null," = Margen Industrial",null,"Margen",{"$f":"E6-E9","v":300911.35079609661},{"$f":"F6-F9","v":12035.593220338982},{"$f":"G6-G9","v":11666.666666666672},{"$f":"H6-H9","v":274800},{"$f":"I6-I9","v":2409.0909090909117},null,null,null,null,null,null,"Composición de las Ventas",null,{"$f":"F40","v":0.1296844181459566},null,{"$f":"G40","v":7.3964497041420121E-2},null,{"$f":"H40","v":0.7527942143326759},null,{"$f":"I40","v":4.3556870479947406E-2}]
[null,null,null,"Margen Bruto Sobre Vtas",{"$f":"(E6-E9)/E6","v":0.49459459368194708},{"$f":"(F6-F9)/F6","v":0.15254237288135591},{"$f":"(G6-G9)/G6","v":0.25925925925925936},{"$f":"(H6-H9)/H6","v":0.6},{"$f":"(I6-I9)/I6","v":9.0909090909091009E-2},null,null,null,null,null,null,null,null,{"$f":"F7","v":0.1296844181459566},null,{"$f":"G7","v":7.3964497041420121E-2},null,{"$f":"H7","v":0.7527942143326759},null,{"$f":"I7","v":4.3556870479947406E-2}]
[null,null,null,"Contribución al Margen I.",{"$f":"SUM(F12:I12)","v":0.99999999999999989},{"$f":"F10/$E$10","v":3.9997139318597968E-2},{"$f":"G10/$E$10","v":3.8771108619868024E-2},{"$f":"H10/$E$10","v":0.91322576989197668},{"$f":"I10/$E$10","v":8.0059821695571687E-3},null,null,null,null,null,null,null,null,{"$f":"R10-R11","v":0},null,{"$f":"T10-T11","v":0},null,{"$f":"V10-V11","v":0},null,{"$f":"X10-X11","v":0}]
[null,"Costes Fijos del Periodo Estimados",null,"Costes de Personal",85465,"Punto Muerto Explotación",null,null,{"$f":"(E13+E14+E15)/E11","v":242058.85290567394},null,null,null,null,null,null,"Margen Indusrtial",null,{"$f":"F43","v":12035.593220338982},null,{"$f":"G43","v":11666.666666666672},null,{"$f":"H43","v":274800},null,{"$f":"I43","v":2409.0909090909117}]
[null,null,null,"Otros Costes de Explotación",20000,"Margen Seguridad Explotación",null,null,{"$f":"E6-I13","v":366341.14709432609},null,null,null,null,null,null,null,null,{"$f":"F10","v":12035.593220338982},null,{"$f":"G10","v":11666.666666666672},null,{"$f":"H10","v":274800},null,{"$f":"I10","v":2409.0909090909117}]
[null,null,null,"Amortizaciones",14256,"Composición de Ventas para el Pto Muerto de Explotación",null,null,null,null,null,null,null,null,null,null,null,{"$f":"R13-R14","v":0},null,{"$f":"T13-T14","v":0},null,{"$f":"V13-V14","v":0},null,{"$f":"X13-X14","v":0}]
[null,"Resultado de Explotación Estimado",null,null,{"$f":"E10-E13-E14-E15","v":181190.35079609661},{"$f":"F5","v":"Gama Blanca"},{"$f":"G5","v":"Gama Marrón"},{"$f":"H5","v":"Muebles"},{"$f":"I5","v":"Electrónica"},null,null,null,null,null,null,"Contribuc. Margen Industrial",null,{"$f":"F45","v":3.9997139318597968E-2},null,{"$f":"G45","v":3.8771108619868024E-2},null,{"$f":"H45","v":0.91322576989197668},null,{"$f":"I45","v":8.0059821695571687E-3}]
[null,null,null,null,null,{"$f":"$I$13*F7","v":31391.261496150022},{"$f":"$I$13*G7","v":17903.761309591267},{"$f":"$I$13*H7","v":182220.50399539559},{"$f":"$I$13*I7","v":10543.32610453708},null,null,null,null,null,null,null,null,{"$f":"F12","v":3.9997139318597968E-2},null,{"$f":"G12","v":3.8771108619868024E-2},null,{"$f":"H12","v":0.91322576989197668},null,{"$f":"I12","v":8.0059821695571687E-3}]
[null,"Rtos Financ. y Extraordinarios",null,"Costes Financieros",15250,"Punto Muerto Total",null,null,{"$f":"(E13+E14+E15+E18+E19+E20)/E11","v":329975.30115533288},null,null,null,null,null,null,null,null,{"$f":"R16-R17","v":0},null,{"$f":"T16-T17","v":0},null,{"$f":"V16-V17","v":0},null,{"$f":"X16-X17","v":0}]
[null,null,null,"Costes Extraordinarios ",2546,"Margen Seguridad Total",null,null,{"$f":"E6-I18","v":278424.69884466712},null,null,null,null,null,null,"Volumen de Ventas Total",null,null,null,null,"Margen Medio sobre Coste"]
[null,null,null,"Coste de Oportunidad",25687,"Composición de Ventas para el Pto Muerto de Explotación"]
[null,"Resultado  Final Estimado",null,null,{"$f":"E16-E18-E19-E20","v":137707.35079609661},{"$f":"F5","v":"Gama Blanca"},{"$f":"G5","v":"Gama Marrón"},{"$f":"H5","v":"Muebles"},{"$f":"I5","v":"Electrónica"}]
[null,null,null,null,null,{"$f":"$I$18*F7","v":42792.654932866149},{"$f":"$I$18*G7","v":24406.457186045332},{"$f":"$I$18*H7","v":248403.49758241695},{"$f":"$I$18*I7","v":14372.691454004475}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    Margen Industrial   Rtdo de Explotación Estimado  Rtdo Final Estimado   Pto. Muerto de Explotac.   Pto Muerto Total"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Total","Línea de Negocio 1","Línea de Negocio 2","Línea de Negocio 3","Línea de Negocio 4"]
[]
[null,null,null,null,null,{"$f":"F5","v":"Gama Blanca"},"Gama Marrón","Muebles","Electrónica"]
[null,"Ingresos",null,"Volumen de Vtas",{"$f":"SUM(F39:I39)","v":608400},{"$f":"F6","v":78900},{"$f":"G6","v":45000},{"$f":"H6","v":458000},{"$f":"I6","v":26500}]
[null,null,null,"Composición de las Vtas",{"$f":"SUM(F40:I40)","v":1},{"$f":"F39/$E$6","v":0.1296844181459566},{"$f":"G39/$E$6","v":7.3964497041420121E-2},{"$f":"H39/$E$6","v":0.7527942143326759},{"$f":"I39/$E$6","v":4.3556870479947406E-2}]
[null,"Costes Variables Directos",null,"Margen Medio sobre Coste",{"$f":"(E39-E42)/E42","v":0.97860962209552904},{"$f":"F8*100","v":18},{"$f":"G8*100","v":35},{"$f":"H8*100","v":150},{"$f":"I8*100","v":10}]
[null,null,null,"Ventas al Coste Estimadas",{"$f":"SUM(F42:I42)","v":307488.64920390339},{"$f":"F39/(1+(F41/100))","v":66864.406779661018},{"$f":"G39/(1+(G41/100))","v":33333.333333333328},183200,24090.909090909088]
[null," = Margen Industrial",null,"Margen",{"$f":"E39-E42","v":300911.35079609661},{"$f":"F39-F42","v":12035.593220338982},{"$f":"G39-G42","v":11666.666666666672},{"$f":"H39-H42","v":274800},{"$f":"I39-I42","v":2409.0909090909117}]
[null,null,null,"Margen Bruto Sobre Vtas",{"$f":"(E39-E42)/E39","v":0.49459459368194708},{"$f":"(F39-F42)/F39","v":0.15254237288135591},{"$f":"(G39-G42)/G39","v":0.25925925925925936},{"$f":"(H39-H42)/H39","v":0.6},{"$f":"(I39-I42)/I39","v":9.0909090909091009E-2}]
[null,null,null,"Contribución al Margen I.",{"$f":"SUM(F45:I45)","v":0.99999999999999989},{"$f":"F43/$E$43","v":3.9997139318597968E-2},{"$f":"G43/$E$43","v":3.8771108619868024E-2},0.91322576989197668,8.0059821695571687E-3]
[null,"Costes Fijos del Periodo Estimados",null,"Costes de Personal",{"$f":"E13","v":85465},"Punto Muerto Explotación",null,null,{"$f":"(E46+E47+E48)/E44","v":242058.85290567394}]
[null,null,null,"Otros Costes de Explotación",{"$f":"E14","v":20000},"Margen Seguridad Explotación",null,null,{"$f":"E39-I46","v":366341.14709432609}]
[null,null,null,"Amortizaciones",{"$f":"E15","v":14256},"Composición de Ventas para el Pto Muerto de Explotación"]
[null,"Resultado de Explotación Estimado",null,null,{"$f":"E43-E46-E47-E48","v":181190.35079609661},{"$f":"F38","v":"Gama Blanca"},{"$f":"G38","v":"Gama Marrón"},{"$f":"H38","v":"Muebles"},{"$f":"I38","v":"Electrónica"}]
[null,null,null,null,null,{"$f":"$I$13*F40","v":31391.261496150022},{"$f":"$I$13*G40","v":17903.761309591267},{"$f":"$I$13*H40","v":182220.50399539559},{"$f":"$I$13*I40","v":10543.32610453708}]
[null,"Rtos Financ. y Extraordinarios",null,"Costes Financieros",{"$f":"E18","v":15250},"Punto Muerto Total",null,null,{"$f":"(E46+E47+E48+E51+E52+E53)/E44","v":329975.30115533288}]
[null,null,null,"Costes Extraordinarios ",{"$f":"E19","v":2546},"Margen Seguridad Total",null,null,{"$f":"E39-I51","v":278424.69884466712}]
[null,null,null,"Coste de Oportunidad",{"$f":"E20","v":25687},"Composición de Ventas para el Pto Muerto de Explotación"]
[null,"Resultado  Final Estimado",null,null,{"$f":"E49-E51-E52-E53","v":137707.35079609661},{"$f":"F38","v":"Gama Blanca"},{"$f":"G38","v":"Gama Marrón"},{"$f":"H38","v":"Muebles"},"Electrónica"]
[null,null,null,null,null,{"$f":"$I$18*F40","v":42792.654932866149},{"$f":"$I$18*G40","v":24406.457186045332},{"$f":"$I$18*H40","v":248403.49758241695},{"$f":"$I$18*I40","v":14372.691454004475}]